package com.team.pulldown.mapper;

import com.team.pulldown.model.XiaLaVo;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * Created by 李红历 on 2022/7/5.
 */
@Mapper
public interface PullDownMapper {
    @Select("SELECT legalPersonCode legalPersonCode,legalPersonName legalPersonName FROM legalperson")
    List<XiaLaVo> getPerson();
    @Select("SELECT code code,name name FROM ware")
    List<XiaLaVo> getWare();
    @Select("SELECT code code,name name FROM sign")
    List<XiaLaVo> getSign();
    @Select("SELECT code code,name name FROM area")
    List<XiaLaVo> getArea();
    @Select("SELECT code code,name name FROM property")
    List<XiaLaVo> getProperty();
}
